300
|
How can I change the font for entire item
with ComboBox1 do
begin
Columns.Add('Default');
Items.AddItem('default font');
f := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('StdFont'))) as stdole_TLB.StdFont);
with f do
begin
Name := 'Tahoma';
Size := 12;
end;
with Items do
begin
ItemFont[AddItem('new font')] := (IUnknown(f) as stdole_TLB.StdFont);
end;
end
|
299
|
How do I vertically align a cell
![](images/excomboboxq299.png)
with ComboBox1 do
begin
DrawGridLines := EXCOMBOBOXLib_TLB.exRowLines;
(IUnknown(Columns.Add('MultipleLine')) as EXCOMBOBOXLib_TLB.Column).Def[EXCOMBOBOXLib_TLB.exCellSingleLine] := OleVariant(False);
Columns.Add('VAlign');
with Items do
begin
h := AddItem('This is a bit of long text that should break the line');
CellCaption[OleVariant(h),OleVariant(1)] := 'top';
CellVAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.exTop;
h := AddItem('This is a bit of long text that should break the line');
CellCaption[OleVariant(h),OleVariant(1)] := 'middle';
CellVAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.exMiddle;
h := AddItem('This is a bit of long text that should break the line');
CellCaption[OleVariant(h),OleVariant(1)] := 'bottom';
CellVAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.exBottom;
end;
end
|
298
|
How can I change the position of an item
![](images/excomboboxq298.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
AddItem('Item 1');
AddItem('Item 2');
ItemPosition[AddItem('Item 3')] := 0;
end;
end
|
297
|
How do I find an item based on a path
![](images/excomboboxq297.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
ItemData[InsertItem(h,Null,'Child 2')] := OleVariant(1234);
ExpandItem[h] := True;
ItemBold[FindPath['Root 1\Child 1']] := True;
end;
end
|
296
|
How do I find an item
![](images/excomboboxq296.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
ItemBold[FindItem['Child 2',OleVariant(0),Null]] := True;
end;
end
|
295
|
How can I insert a hyperlink or an anchor element
![](images/excomboboxq295.png)
with ComboBox1 do
begin
Columns.Add('Column');
with Items do
begin
CellCaptionFormat[OleVariant(AddItem('Just an <a1>anchor</a> element ...')),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
end;
with Items do
begin
CellCaptionFormat[OleVariant(AddItem('Just another <a2>anchor</a> element ...')),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
end;
end
|
294
|
How do I find the index of the item based on its handle
![](images/excomboboxq294.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
ItemBold[ItemByIndex[ItemToIndex[h]]] := True;
end;
end
|
293
|
How do I find the handle of the item based on its index
![](images/excomboboxq293.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
ItemBold[ItemByIndex[1]] := True;
end;
end
|
292
|
How can I find the cell being clicked in a radio group
![](images/excomboboxq292.png)
with ComboBox1 do
begin
MarkSearchColumn := False;
SelBackColor := RGB(255,255,128);
SelForeColor := RGB(0,0,0);
Columns.Add('C1');
Columns.Add('C2');
Columns.Add('C3');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Radio 1';
CellHasRadioButton[OleVariant(h),OleVariant(1)] := True;
CellRadioGroup[OleVariant(h),OleVariant(1)] := 1234;
CellCaption[OleVariant(h),OleVariant(2)] := 'Radio 2';
CellHasRadioButton[OleVariant(h),OleVariant(2)] := True;
CellRadioGroup[OleVariant(h),OleVariant(2)] := 1234;
CellState[OleVariant(h),OleVariant(1)] := 1;
CellBold[Null,OleVariant(CellChecked[1234])] := True;
end;
end
|
291
|
Can I add a +/- ( expand / collapse ) buttons to each item, so I can load the child items later
![](images/excomboboxq291.png)
with ComboBox1 do
begin
LinesAtRoot := EXCOMBOBOXLib_TLB.exLinesAtRoot;
Columns.Add('Default');
with Items do
begin
ItemHasChildren[AddItem('parent item with no child items')] := True;
AddItem('next item');
end;
end
|
290
|
Can I let the user to resize at runtime the specified item
![](images/excomboboxq290.png)
with ComboBox1 do
begin
ScrollBySingleLine := True;
DrawGridLines := EXCOMBOBOXLib_TLB.exRowLines;
Columns.Add('Default');
with Items do
begin
ItemAllowSizing[AddItem('resizable item')] := True;
AddItem('not resizable item');
end;
end
|
289
|
How can I change the size ( width, height ) of the picture
![](images/excomboboxq289.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
CellPicture[OleVariant(h),OleVariant(0)] := ComboBox1.ExecuteTemplate('loadpicture(`c:\exontrol\images\zipdisk.gif`)');
CellPictureWidth[OleVariant(h),OleVariant(0)] := 24;
CellPictureHeight[OleVariant(h),OleVariant(0)] := 24;
ItemHeight[h] := 32;
h := AddItem('Root 2');
CellPicture[OleVariant(h),OleVariant(0)] := ComboBox1.ExecuteTemplate('loadpicture(`c:\exontrol\images\zipdisk.gif`)');
ItemHeight[h] := 48;
end;
end
|
288
|
How do I unselect an item
![](images/excomboboxq288.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
SelectItem[h] := False;
end;
end
|
287
|
How do I find the selected item
![](images/excomboboxq287.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
SelectItem[h] := True;
ItemBold[SelectedItem[0]] := True;
end;
end
|
286
|
How do I select an item
![](images/excomboboxq286.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
SelectItem[h] := True;
end;
end
|
285
|
Can I display a button with some picture or icon inside
![](images/excomboboxq285.png)
with ComboBox1 do
begin
HTMLPicture['p1'] := 'c:\exontrol\images\zipdisk.gif';
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := ' Button <img>p1</img> ';
CellCaptionFormat[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.exHTML;
CellHAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.RightAlignment;
CellHasButton[OleVariant(h),OleVariant(1)] := True;
ItemHeight[h] := 48;
end;
end
|
284
|
Can I display a button with some picture or icon inside
![](images/excomboboxq284.png)
with ComboBox1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := ' Button <img>1</img> ';
CellCaptionFormat[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.exHTML;
CellHAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.RightAlignment;
CellHasButton[OleVariant(h),OleVariant(1)] := True;
end;
end
|
283
|
Can I display a button with some icon inside
![](images/excomboboxq283.png)
with ComboBox1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := ' <img>1</img> ';
CellCaptionFormat[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.exHTML;
CellHAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.RightAlignment;
CellHasButton[OleVariant(h),OleVariant(1)] := True;
end;
end
|
282
|
How can I assign multiple icon/picture to a cell
![](images/excomboboxq282.png)
with ComboBox1 do
begin
HTMLPicture['p1'] := 'c:\exontrol\images\zipdisk.gif';
HTMLPicture['p2'] := 'c:\exontrol\images\auction.gif';
Columns.Add('Default');
with Items do
begin
h := AddItem('text <img>p1</img> another picture <img>p2</img> and so on');
CellCaptionFormat[OleVariant(h),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
CellPicture[OleVariant(h),OleVariant(0)] := ComboBox1.ExecuteTemplate('loadpicture(`c:\exontrol\images\colorize.gif`)');
ItemHeight[h] := 48;
AddItem('Root 2');
end;
end
|
281
|
How can I assign an icon/picture to a cell
![](images/excomboboxq281.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
CellPicture[OleVariant(h),OleVariant(0)] := ComboBox1.ExecuteTemplate('loadpicture(`c:\exontrol\images\zipdisk.gif`)');
ItemHeight[h] := 48;
AddItem('Root 2');
end;
end
|
280
|
How can I assign multiple icons/pictures to a cell
![](images/excomboboxq280.png)
with ComboBox1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Columns.Add('Default');
with Items do
begin
h := AddItem('Root <img>1</img> 1, <img>2</img>, ... and so on ');
CellCaptionFormat[OleVariant(h),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
end;
end
|
279
|
How can I assign multiple icons/pictures to a cell
![](images/excomboboxq279.png)
with ComboBox1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
CellImages[OleVariant(h),OleVariant(0)] := '1,2,3';
end;
end
|
278
|
How can I assign an icon/picture to a cell
![](images/excomboboxq278.png)
with ComboBox1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
CellImage[OleVariant(h),OleVariant(0)] := 1;
CellImage[OleVariant(InsertItem(h,Null,'Child 1')),OleVariant(0)] := 2;
CellImage[OleVariant(InsertItem(h,Null,'Child 2')),OleVariant(0)] := 3;
ExpandItem[h] := True;
end;
end
|
277
|
How can I get the handle of an item based on the handle of the cell
![](images/excomboboxq277.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
ItemBold[CellItem[ItemCell[h,OleVariant(0)]]] := True;
end;
end
|
276
|
How can I display a button inside the item or cell
![](images/excomboboxq276.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := ' Button 1 ';
CellHAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.RightAlignment;
CellHasButton[OleVariant(h),OleVariant(1)] := True;
h := AddItem('Cell 2');
CellCaption[OleVariant(h),OleVariant(1)] := ' Button 2 ';
CellHAlignment[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.CenterAlignment;
CellHasButton[OleVariant(h),OleVariant(1)] := True;
end;
end
|
275
|
How can I change the state of a radio button
![](images/excomboboxq275.png)
with ComboBox1 do
begin
MarkSearchColumn := False;
SelBackColor := RGB(255,255,128);
SelForeColor := RGB(0,0,0);
Columns.Add('C1');
Columns.Add('C2');
Columns.Add('C3');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Radio 1';
CellHasRadioButton[OleVariant(h),OleVariant(1)] := True;
CellRadioGroup[OleVariant(h),OleVariant(1)] := 1234;
CellCaption[OleVariant(h),OleVariant(2)] := 'Radio 2';
CellHasRadioButton[OleVariant(h),OleVariant(2)] := True;
CellRadioGroup[OleVariant(h),OleVariant(2)] := 1234;
CellState[OleVariant(h),OleVariant(1)] := 1;
end;
end
|
274
|
How can I assign a radio button to a cell
![](images/excomboboxq274.png)
with ComboBox1 do
begin
MarkSearchColumn := False;
SelBackColor := RGB(255,255,128);
SelForeColor := RGB(0,0,0);
Columns.Add('C1');
Columns.Add('C2');
Columns.Add('C3');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Radio 1';
CellHasRadioButton[OleVariant(h),OleVariant(1)] := True;
CellRadioGroup[OleVariant(h),OleVariant(1)] := 1234;
CellCaption[OleVariant(h),OleVariant(2)] := 'Radio 2';
CellHasRadioButton[OleVariant(h),OleVariant(2)] := True;
CellRadioGroup[OleVariant(h),OleVariant(2)] := 1234;
CellState[OleVariant(h),OleVariant(1)] := 1;
end;
end
|
273
|
How can I change the state of a checkbox
![](images/excomboboxq273.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Check Box';
CellHasCheckBox[OleVariant(h),OleVariant(1)] := True;
CellState[OleVariant(h),OleVariant(1)] := 1;
end;
end
|
272
|
How can I assign a checkbox to a cell
![](images/excomboboxq272.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Check Box';
CellHasCheckBox[OleVariant(h),OleVariant(1)] := True;
end;
end
|
271
|
How can I display an item or a cell on multiple lines
![](images/excomboboxq271.png)
with ComboBox1 do
begin
ScrollBySingleLine := True;
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'This is bit of text that''s shown on multiple lines';
CellSingleLine[OleVariant(h),OleVariant(1)] := EXCOMBOBOXLib_TLB.exCaptionWordWrap;
end;
end
|
270
|
How can I assign a tooltip to a cell
![](images/excomboboxq270.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'tooltip';
CellToolTip[OleVariant(h),OleVariant(1)] := 'This is bit of text that''s shown when the user hovers the cell';
end;
end
|
269
|
How can I associate an extra data to a cell
![](images/excomboboxq269.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Cell 2';
CellData[OleVariant(h),OleVariant(1)] := 'your extra data';
end;
end
|
268
|
How do I enable or disable a cell
![](images/excomboboxq268.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Cell 2';
CellEnabled[OleVariant(h),OleVariant(1)] := False;
end;
end
|
267
|
How do I change the cell's foreground color
![](images/excomboboxq267.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Cell 2';
CellForeColor[OleVariant(h),OleVariant(1)] := $ff;
end;
end
|
266
|
How do I change the visual effect for the cell, using your EBN files
![](images/excomboboxq266.png)
with ComboBox1 do
begin
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Cell 2';
CellBackColor[OleVariant(h),OleVariant(1)] := $1000000;
end;
end
|
265
|
How do I change the cell's background color
![](images/excomboboxq265.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Cell 2';
CellBackColor[OleVariant(h),OleVariant(1)] := $ff;
end;
end
|
264
|
How do I change the caption or value for a particular cell
![](images/excomboboxq264.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
CellCaption[OleVariant(AddItem('Cell 1')),OleVariant(1)] := 'Cell 2';
end;
end
|
263
|
How do I get the handle of the cell
![](images/excomboboxq263.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
CellBold[Null,OleVariant(ItemCell[h,OleVariant(0)])] := True;
end;
end
|
262
|
How do I retrieve the focused item
![](images/excomboboxq262.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
ItemBold[FocusItem] := True;
end;
end
|
261
|
How do I get the number or count of child items
![](images/excomboboxq261.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
AddItem(OleVariant(ChildCount[h]));
end;
end
|
260
|
How do I enumerate the visible items
![](images/excomboboxq260.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
h := AddItem('Root 2');
ItemBold[FirstVisibleItem] := True;
ItemBold[NextVisibleItem[FirstVisibleItem]] := True;
end;
end
|
259
|
How do I enumerate the siblings items
![](images/excomboboxq259.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
h := AddItem('Root 2');
ItemBold[NextSiblingItem[FirstVisibleItem]] := True;
ItemBold[PrevSiblingItem[NextSiblingItem[FirstVisibleItem]]] := True;
end;
end
|
258
|
How do I get the parent item
![](images/excomboboxq258.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
ItemBold[ItemParent[ItemChild[h]]] := True;
end;
end
|
257
|
How do I get the first child item
![](images/excomboboxq257.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
ItemBold[ItemChild[h]] := True;
end;
end
|
256
|
How do I enumerate the root items
![](images/excomboboxq256.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
h := AddItem('Root 2');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ItemBold[RootItem[0]] := True;
ItemUnderline[RootItem[1]] := True;
end;
end
|
255
|
I have a hierarchy, how can I count the number of root items
![](images/excomboboxq255.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root 1');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
h := AddItem('Root 2');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
AddItem(OleVariant(RootCount));
end;
end
|
254
|
How can I make an item unselectable, or not selectable
![](images/excomboboxq254.png)
with ComboBox1 do
begin
Columns.Add('Column');
with Items do
begin
h := AddItem('unselectable - you can''t get selected');
SelectableItem[h] := False;
AddItem('selectable');
end;
end
|
253
|
How can I hide or show an item
![](images/excomboboxq253.png)
with ComboBox1 do
begin
Columns.Add('Column');
with Items do
begin
h := AddItem('hidden');
ItemHeight[h] := 0;
SelectableItem[h] := False;
AddItem('visible');
end;
end
|
252
|
How can I change the height for all items
![](images/excomboboxq252.png)
with ComboBox1 do
begin
DefaultItemHeight := 32;
Columns.Add('Column');
Items.AddItem('One');
Items.AddItem('Two');
end
|
251
|
How do I change the height of an item
![](images/excomboboxq251.png)
with ComboBox1 do
begin
ScrollBySingleLine := True;
Columns.Add('Default');
with Items do
begin
ItemHeight[AddItem('height')] := 128;
end;
Items.AddItem('enabled');
end
|
250
|
How do I disable or enable an item
![](images/excomboboxq250.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
EnableItem[AddItem('disabled')] := False;
end;
Items.AddItem('enabled');
end
|
249
|
How do I display as strikeout a cell
![](images/excomboboxq249.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellStrikeOut[OleVariant(AddItem('strikeout')),OleVariant(0)] := True;
end;
end
|
248
|
How do I display as strikeout a cell or an item
![](images/excomboboxq248.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellCaptionFormat[OleVariant(AddItem('gets <s>strikeout</s> only a portion of text')),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
end;
end
|
247
|
How do I display as strikeout an item
![](images/excomboboxq247.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
ItemStrikeOut[AddItem('strikeout')] := True;
end;
end
|
246
|
How do I underline a cell
![](images/excomboboxq246.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellUnderline[OleVariant(AddItem('underline')),OleVariant(0)] := True;
end;
end
|
245
|
How do I underline a cell or an item
![](images/excomboboxq245.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellCaptionFormat[OleVariant(AddItem('gets <u>underline</u> only a portion of text')),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
end;
end
|
244
|
How do I underline an item
![](images/excomboboxq244.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
ItemUnderline[AddItem('underline')] := True;
end;
end
|
243
|
How do I display as italic a cell
![](images/excomboboxq243.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellItalic[OleVariant(AddItem('italic')),OleVariant(0)] := True;
end;
end
|
242
|
How do I display as italic a cell or an item
![](images/excomboboxq242.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellCaptionFormat[OleVariant(AddItem('gets <i>italic</i> only a portion of text')),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
end;
end
|
241
|
How do I display as italic an item
![](images/excomboboxq241.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
ItemItalic[AddItem('italic')] := True;
end;
end
|
240
|
How do I bold a cell
![](images/excomboboxq240.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellBold[OleVariant(AddItem('bold')),OleVariant(0)] := True;
end;
end
|
239
|
How do I bold a cell or an item
![](images/excomboboxq239.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
CellCaptionFormat[OleVariant(AddItem('gets <b>bold</b> only a portion of text')),OleVariant(0)] := EXCOMBOBOXLib_TLB.exHTML;
end;
end
|
238
|
How do I bold an item
![](images/excomboboxq238.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
ItemBold[AddItem('bold')] := True;
end;
end
|
237
|
How do I change the foreground color for the item
![](images/excomboboxq237.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root');
hC := InsertItem(h,Null,'Child 1');
ItemForeColor[hC] := $ff;
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
end;
end
|
236
|
How do I change the visual appearance for the item, using your EBN technology
![](images/excomboboxq236.png)
with ComboBox1 do
begin
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Columns.Add('Default');
with Items do
begin
h := AddItem('Root');
hC := InsertItem(h,Null,'Child 1');
ItemBackColor[hC] := $1000000;
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
end;
end
|
235
|
How do I change the background color for the item
![](images/excomboboxq235.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root');
hC := InsertItem(h,Null,'Child 1');
ItemBackColor[hC] := $ff;
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
end;
end
|
234
|
How do I expand or collapse an item
![](images/excomboboxq234.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
end;
end
|
233
|
How do I associate an extra data to an item
![](images/excomboboxq233.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
ItemData[AddItem('item')] := 'your extra data';
end;
end
|
232
|
How do I get the number or count of items
![](images/excomboboxq232.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
end;
with Items do
begin
AddItem(OleVariant(ItemCount));
end;
end
|
231
|
How can I change at runtime the parent of the item
![](images/excomboboxq231.png)
with ComboBox1 do
begin
LinesAtRoot := EXCOMBOBOXLib_TLB.exLinesAtRoot;
Columns.Add('Default');
with Items do
begin
hP := AddItem('Root');
hC := AddItem('Child');
SetParent(hC,hP);
end;
end
|
230
|
How can I sort the items
![](images/excomboboxq230.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
end;
Columns.Item['Default'].SortOrder := EXCOMBOBOXLib_TLB.SortDescending;
end
|
229
|
How do I sort the child items
![](images/excomboboxq229.png)
with ComboBox1 do
begin
Columns.Add('Default');
with Items do
begin
h := AddItem('Root');
InsertItem(h,Null,'Child 1');
InsertItem(h,Null,'Child 2');
ExpandItem[h] := True;
SortChildren(h,OleVariant(0),False);
end;
end
|
228
|
How can I remove or delete all items
![](images/excomboboxq228.png)
with ComboBox1 do
begin
Columns.Add('Default');
Items.AddItem('removed item');
Items.RemoveAllItems();
end
|
227
|
How can I remove or delete an item
![](images/excomboboxq227.png)
with ComboBox1 do
begin
Columns.Add('Default');
h := Items.AddItem('removed item');
Items.RemoveItem(h);
end
|
226
|
How can I add or insert child items
![](images/excomboboxq226.png)
with ComboBox1 do
begin
LinesAtRoot := EXCOMBOBOXLib_TLB.exLinesAtRoot;
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := AddItem('Cell 1');
CellCaption[OleVariant(h),OleVariant(1)] := 'Cell 2';
CellCaption[OleVariant(InsertItem(h,Null,'Cell 3')),OleVariant(1)] := 'Cell 4';
CellCaption[OleVariant(InsertItem(h,Null,'Cell 5')),OleVariant(1)] := 'Cell 6';
ExpandItem[h] := True;
end;
end
|
225
|
How can I add or insert a child item
![](images/excomboboxq225.png)
with ComboBox1 do
begin
LinesAtRoot := EXCOMBOBOXLib_TLB.exLinesAtRoot;
Columns.Add('Default');
with Items do
begin
InsertItem(AddItem('root'),Null,'child');
end;
end
|
224
|
How can I add or insert an item
![](images/excomboboxq224.png)
with ComboBox1 do
begin
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
CellCaption[OleVariant(AddItem('Cell 1')),OleVariant(1)] := 'Cell 2';
h := AddItem('Cell 3');
CellCaption[OleVariant(h),OleVariant(1)] := 'Cell 4';
end;
end
|
223
|
How can I add or insert an item
![](images/excomboboxq223.png)
with ComboBox1 do
begin
Columns.Add('Default');
Items.AddItem('new item');
end
|
222
|
How can I get the columns as they are shown in the control's sortbar
with ComboBox1 do
begin
var_Object := (IUnknown(Columns.ItemBySortPosition[OleVariant(0)]) as _TLB.Object);
end
|
221
|
How can I access the properties of a column
![](images/excomboboxq221.png)
with ComboBox1 do
begin
Columns.Add('A');
Columns.Item['A'].HeaderBold := True;
end
|
220
|
How can I remove all the columns
![](images/excomboboxq220.png)
with ComboBox1 do
begin
Columns.Clear();
end
|
219
|
How can I remove a column
![](images/excomboboxq219.png)
with ComboBox1 do
begin
Columns.Remove('A');
end
|
218
|
How can I get the number or the count of columns
with ComboBox1 do
begin
var_Count := Columns.Count;
end
|
217
|
How can I change the font for all cells in the entire column
![](images/excomboboxq217.png)
with ComboBox1 do
begin
f := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('StdFont'))) as stdole_TLB.StdFont);
with f do
begin
Name := 'Tahoma';
Size := 12;
end;
with ConditionalFormats.Add('1',Null) do
begin
Font := (IUnknown(f) as stdole_TLB.StdFont);
ApplyTo := EXCOMBOBOXLib_TLB.exFormatToColumns;
end;
Columns.Add('Column');
Items.AddItem(OleVariant(0));
Items.AddItem(OleVariant(1));
end
|
216
|
How can I change the background color for all cells in the column
![](images/excomboboxq216.png)
with ComboBox1 do
begin
var_ConditionalFormat := ConditionalFormats.Add('1',Null);
with var_ConditionalFormat do
begin
BackColor := $ff;
ApplyTo := EXCOMBOBOXLib_TLB.exFormatToColumns;
end;
Columns.Add('Column');
Items.AddItem(OleVariant(0));
Items.AddItem(OleVariant(1));
end
|
215
|
How can I change the foreground color for all cells in the column
![](images/excomboboxq215.png)
with ComboBox1 do
begin
var_ConditionalFormat := ConditionalFormats.Add('1',Null);
with var_ConditionalFormat do
begin
ForeColor := $ff;
ApplyTo := EXCOMBOBOXLib_TLB.exFormatToColumns;
end;
Columns.Add('Column');
Items.AddItem(OleVariant(0));
Items.AddItem(OleVariant(1));
end
|
214
|
How can I show as strikeout all cells in the column
![](images/excomboboxq214.png)
with ComboBox1 do
begin
var_ConditionalFormat := ConditionalFormats.Add('1',Null);
with var_ConditionalFormat do
begin
StrikeOut := True;
ApplyTo := EXCOMBOBOXLib_TLB.exFormatToColumns;
end;
Columns.Add('Column');
Items.AddItem(OleVariant(0));
Items.AddItem(OleVariant(1));
end
|
213
|
How can I underline all cells in the column
![](images/excomboboxq213.png)
with ComboBox1 do
begin
var_ConditionalFormat := ConditionalFormats.Add('1',Null);
with var_ConditionalFormat do
begin
Underline := True;
ApplyTo := EXCOMBOBOXLib_TLB.exFormatToColumns;
end;
Columns.Add('Column');
Items.AddItem(OleVariant(0));
Items.AddItem(OleVariant(1));
end
|
212
|
How can I show in italic all data in the column
![](images/excomboboxq212.png)
with ComboBox1 do
begin
var_ConditionalFormat := ConditionalFormats.Add('1',Null);
with var_ConditionalFormat do
begin
Italic := True;
ApplyTo := EXCOMBOBOXLib_TLB.exFormatToColumns;
end;
Columns.Add('Column');
Items.AddItem(OleVariant(0));
Items.AddItem(OleVariant(1));
end
|
211
|
How can I bold the entire column
![](images/excomboboxq211.png)
with ComboBox1 do
begin
var_ConditionalFormat := ConditionalFormats.Add('1',Null);
with var_ConditionalFormat do
begin
Bold := True;
ApplyTo := EXCOMBOBOXLib_TLB.exFormatToColumns;
end;
Columns.Add('Column');
Items.AddItem(OleVariant(0));
Items.AddItem(OleVariant(1));
end
|
210
|
How can I display a computed column and highlight some values that are negative or less than a value
![](images/excomboboxq210.png)
with ComboBox1 do
begin
Columns.Add('A');
Columns.Add('B');
(IUnknown(Columns.Add('(A+B)*1.19')) as EXCOMBOBOXLib_TLB.Column).ComputedField := '(%0 + %1) * 1.19';
with Items do
begin
CellCaption[OleVariant(AddItem(OleVariant(1))),OleVariant(1)] := OleVariant(2);
end;
with Items do
begin
CellCaption[OleVariant(AddItem(OleVariant(10))),OleVariant(1)] := OleVariant(20);
end;
var_ConditionalFormat := ConditionalFormats.Add('%2 > 10',Null);
with var_ConditionalFormat do
begin
Bold := True;
ForeColor := $ff;
ApplyTo := EXCOMBOBOXLib_TLB.FormatApplyToEnum($2);
end;
end
|
209
|
Can I display a computed column so it displays the VAT, or SUM
![](images/excomboboxq209.png)
with ComboBox1 do
begin
Columns.Add('A');
Columns.Add('B');
(IUnknown(Columns.Add('(A+B)*1.19')) as EXCOMBOBOXLib_TLB.Column).ComputedField := '(%0 + %1) * 1.19';
with Items do
begin
CellCaption[OleVariant(AddItem(OleVariant(1))),OleVariant(1)] := OleVariant(2);
end;
with Items do
begin
CellCaption[OleVariant(AddItem(OleVariant(10))),OleVariant(1)] := OleVariant(20);
end;
end
|
208
|
How can I show a column that adds values in the cells
![](images/excomboboxq208.png)
with ComboBox1 do
begin
Columns.Add('A');
Columns.Add('B');
(IUnknown(Columns.Add('A+B')) as EXCOMBOBOXLib_TLB.Column).ComputedField := '%0 + %1';
with Items do
begin
CellCaption[OleVariant(AddItem(OleVariant(1))),OleVariant(1)] := OleVariant(2);
end;
with Items do
begin
CellCaption[OleVariant(AddItem(OleVariant(10))),OleVariant(1)] := OleVariant(20);
end;
end
|
207
|
Is there any function to filter the control's data as I type, so the items being displayed include the typed characters
![](images/excomboboxq207.png)
with ComboBox1 do
begin
var_Column := (IUnknown(Columns.Add('Filter')) as EXCOMBOBOXLib_TLB.Column);
with var_Column do
begin
FilterOnType := True;
DisplayFilterButton := True;
AutoSearch := EXCOMBOBOXLib_TLB.exContains;
end;
Items.AddItem('Canada');
Items.AddItem('USA');
end
|
206
|
Is there any function to filter the control's data as I type, something like filter on type
![](images/excomboboxq206.png)
with ComboBox1 do
begin
var_Column := (IUnknown(Columns.Add('Filter')) as EXCOMBOBOXLib_TLB.Column);
with var_Column do
begin
FilterOnType := True;
DisplayFilterButton := True;
end;
Items.AddItem('Canada');
Items.AddItem('USA');
end
|
205
|
How can I programmatically filter a column
![](images/excomboboxq205.png)
with ComboBox1 do
begin
with (IUnknown(Columns.Add('Filter')) as EXCOMBOBOXLib_TLB.Column) do
begin
DisplayFilterButton := True;
FilterType := EXCOMBOBOXLib_TLB.exNonBlanks;
end;
Items.AddItem(Null);
Items.AddItem('not empty');
ApplyFilter();
end
|
204
|
How can I show or display the control's filter
![](images/excomboboxq204.png)
with ComboBox1 do
begin
(IUnknown(Columns.Add('Filter')) as EXCOMBOBOXLib_TLB.Column).DisplayFilterButton := True;
end
|
203
|
How can I customize the items being displayed in the drop down filter window
![](images/excomboboxq203.png)
with ComboBox1 do
begin
with (IUnknown(Columns.Add('Custom Filter')) as EXCOMBOBOXLib_TLB.Column) do
begin
DisplayFilterButton := True;
DisplayFilterPattern := False;
CustomFilter := 'Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||Text Documents (*.log,*.txt)||*.t' +
'xt|*.log';
FilterType := EXCOMBOBOXLib_TLB.exPattern;
Filter := '*.xls';
end;
Items.AddItem('excel.xls');
Items.AddItem('word.doc');
Items.AddItem('pp.pps');
Items.AddItem('text.txt');
ApplyFilter();
end
|
202
|
How can I change the order or the position of the columns in the sort bar
![](images/excomboboxq202.png)
with ComboBox1 do
begin
SortBarVisible := True;
SortBarColumnWidth := 48;
(IUnknown(Columns.Add('C1')) as EXCOMBOBOXLib_TLB.Column).SortOrder := EXCOMBOBOXLib_TLB.SortAscending;
(IUnknown(Columns.Add('C2')) as EXCOMBOBOXLib_TLB.Column).SortOrder := EXCOMBOBOXLib_TLB.SortDescending;
Columns.Item['C2'].SortPosition := 0;
end
|
201
|
How do I arrange my columns on multiple levels
![](images/excomboboxq201.png)
with ComboBox1 do
begin
(IUnknown(Columns.Add('S')) as EXCOMBOBOXLib_TLB.Column).Width := 32;
(IUnknown(Columns.Add('Level 2')) as EXCOMBOBOXLib_TLB.Column).LevelKey := OleVariant(1);
(IUnknown(Columns.Add('Level 3')) as EXCOMBOBOXLib_TLB.Column).LevelKey := OleVariant(1);
(IUnknown(Columns.Add('Level 4')) as EXCOMBOBOXLib_TLB.Column).LevelKey := OleVariant(1);
(IUnknown(Columns.Add('Level 1')) as EXCOMBOBOXLib_TLB.Column).LevelKey := '2';
(IUnknown(Columns.Add('Level 2')) as EXCOMBOBOXLib_TLB.Column).LevelKey := '2';
(IUnknown(Columns.Add('Level 3')) as EXCOMBOBOXLib_TLB.Column).LevelKey := '2';
(IUnknown(Columns.Add('Level 4')) as EXCOMBOBOXLib_TLB.Column).LevelKey := '2';
(IUnknown(Columns.Add('E')) as EXCOMBOBOXLib_TLB.Column).Width := 32;
end
|